@foreach($category as $key => $c)
@if($c?->title === 'Hookah' || $c?->title === 'Glass Bong Percolator' || $c?->title === 'Hookah Flavours' || $c?->title === 'Hookah Accessories')
@php
$products = DB::table('product')->where(['product.is_show' => 1, 'category' => $c->id])->orderBy('id', 'desc')->limit('5')->get();
@endphp
@foreach($products as $p)
@php
$variant = DB::table('product_variance_data')->where('product_id', $p->id)->first();
$product_img = DB::table('product_images')->where(['product_id'=>$p->id, 'variant_id' => $variant->id])->first();
$subcategory = DB::table('subcategory')->where('id', $p->subcategory)->first();
@endphp
@if($variant->sale_price < $variant->reg_price)
Sale
@endif
{{$subcategory?->title}}
₹{{number_format($variant->reg_price, 2)}}₹{{number_format($variant->sale_price, 2)}}
0 Reviews
@endforeach
@endif
@endforeach